package personal.hrsw1.demo1.mapper;

import com.baomidou.mybatisplus.annotation.TableName;
import org.apache.ibatis.annotations.*;
import personal.hrsw1.demo1.domain.SysOrder;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import personal.hrsw1.demo1.domain.SysOrderDetail;

import java.util.List;

/**
* @author Administrator
* @description 针对表【sys_order】的数据库操作Mapper
* @createDate 2025-04-25 16:14:59
* @Entity personal.hrsw1.demo1.domain.SysOrder
*/
@Mapper
@TableName("syo")
public interface SysOrderMapper extends BaseMapper<SysOrder> {
    @Select("select * from sys_order")
    List<SysOrder> selectAll();
    @Select("select * from sys_order syo,sys_order_detail syod where syo.id=syod.id")
    List<SysOrder> findById(String id);
    @Select("select * from sys_order syo,sys_order_detail syod where syo.id=syod.id")
    List<SysOrder> selectOrdersWithDetails();
}




